<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<html>
<head>
<%@ include file="/WEB-INF/views/include.inc.jsp"%>
</head>
<body>
	<h1 style="text-align:center">各风电场物资数据统计表</h1>
	<table id="init_demo" class="datatables table table-striped table-bordered table-condensed" 
			datatables-scroll-y="400px"
			datatables-left-columns="1"
			datatables-colvis-group="
			buttons[0]={extend: 'colvisGroup',text: '计划/采购',
			show: [ 1, 2,3, 4, 5,6,7,8,9,10,11,12,37 ],hide: [ 13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]};
			buttons[1]={extend: 'colvisGroup',text: '入库',
	        show: [ 13,14,15,16,17,18,19,20,37 ],hide: [ 1, 2,3, 4, 5,6,7,8,9,10,11,12,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]};
	        buttons[2]={extend: 'colvisGroup',text: '库存',
	        show: [21,22,23,24,25,26,27,28 ,37 ],hide: [ 1, 2,3, 4, 5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,29,30,31,32,33,34,35,36]};
	        buttons[3]=   {extend: 'colvisGroup',text: '出库',
	        show: [ 29,30,31,32,33,34,35,36,37 ],hide: [ 1, 2,3, 4, 5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,]};
			"
			datatables-footer-callback="2,3,4,11,12,21,22,23"
			cellspacing="0" width="100%">
		<thead>
			<tr>
				<th rowspan="3" style="text-align:center">部门</th>
				<th colspan="6" style="text-align:center">计划</th>
				<th colspan="6" style="text-align:center">采购</th>
				<th colspan="4" style="text-align:center">一级库</th>
				<th colspan="4" style="text-align:center">二级库</th>
				<th colspan="4" style="text-align:center">当前库存</th>
				<th colspan="4" style="text-align:center">历史库存</th>
				<th colspan="4" style="text-align:center">当前出库</th>
				<th colspan="4" style="text-align:center">历史出库</th>
				<th rowspan="3" style="text-align:center">操作</th>
			</tr>
			<tr>
			  <th colspan="2" style="text-align:center">审批中</th>
			  <th colspan="2" style="text-align:center">审批完</th>
			  <th colspan="2" style="text-align:center">合计</th>
			  <th colspan="2" style="text-align:center">未采购</th>
			  <th colspan="2" style="text-align:center">已采购</th>
			  <th colspan="2" style="text-align:center">合计</th>
			  <th colspan="2" style="text-align:center">未入库</th>
			  <th colspan="2" style="text-align:center">已入库</th>
			  <th colspan="2" style="text-align:center">未入库</th>
			  <th colspan="2" style="text-align:center">已入库</th>
			  <th colspan="2" style="text-align:center">一级库</th>
			  <th colspan="2" style="text-align:center">二级库</th>
			  <th colspan="2" style="text-align:center">一级库</th>
			  <th colspan="2" style="text-align:center">二级库</th>
			  <th colspan="2" style="text-align:center">一级库</th>
			  <th colspan="2" style="text-align:center">二级库</th>
			  <th colspan="2" style="text-align:center">一级库</th>
			  <th colspan="2" style="text-align:center">二级库</th>
		  	</tr>
			<tr>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
			  <th style="text-align:center">数量</th>
			  <th style="text-align:center">总价（元）</th>
		  </tr>
		</thead>
		
		<tfoot>
            <tr>
                <th>合计:</th>
                <c:forEach begin="1" end="37">
                	<th></th>
                </c:forEach>
            </tr>
        </tfoot>
		<!-- 模拟数据可以忽略 -->
        <tbody>
        	<c:forEach begin="1" end="30" var="firstVar">
            <tr>
                <td>风场名称${firstVar}</td>
                <c:forEach begin="1" end="36" var="secondVar">
                	<td>${firstVar*secondVar}</td>
                </c:forEach>
                <td>链接文字</td>
            </tr>
            </c:forEach>
        </tbody>
        <!-- 模拟数据可以忽略 --> 
	</table>
	<a href="${contextPath}/jxls1/adjacentlists/xls">jxls1 demo</a>
	 | <a href="${contextPath}/jxls2/object_collection_template/xls">jxls2 demo</a>
</body>
</html>